| SaTrans |
| Logical Entity Name | SaTrans |
| Default Table Name | SaTrans |
| Physical Only | NO |
| Definition | |
| Note |
| SaTrans Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SaTransID |
int | NO | ||
| SyStudentID | int | NO | ||
| AdEnrollID | int | NO | ||
| Source | char(1) | NO | ||
| Type | char(1) | NO | ||
| SyCampusID | int | NO | ||
| SaBillCode | char(8) | NO | ||
| TranNum | numeric(4, 0) | NO | ||
| Descrip | varchar(100) | YES | ||
| Status | char(1) | NO | ||
| Date | datetime | NO | ||
| PostDate | datetime | NO | ||
| Amount | money | NO | ||
| PaymentType | char(1) | YES | ||
| Discount | money | NO | ||
| Payments | money | NO | ||
| BatchNo | char(8) | NO | ||
| SaRevenueDetailID | int | YES | ||
| FaPmtPeriodID | int | NO | ||
| AcademicYear | numeric(3, 0) | NO | ||
| AdTermID | int | NO | ||
| Ref | char(75) | NO | ||
| CheckNo | varchar(20) | NO | ||
| SaCCID | int | YES | ||
| ReceiptNo | varchar(16) | YES | ||
| DateApplied | datetime | YES | ||
| SentBack | bit | NO | ||
| SaBankAccountID | int | YES | ||
| SaBankDepID | int | NO | ||
| AmRepID | int | NO | ||
| CommRate | money | NO | ||
| CommPaid | bit | NO | ||
| CommDate | datetime | YES | ||
| GLPost | bit | NO | ||
| PostAccount | nvarchar(100) | NO | ||
| OffsetAccount | nvarchar(100) | NO | ||
| FaStudentAidID | int | NO | ||
| FADisbID | int | YES | ||
| FaRefundID | int | YES | ||
| SaBillingBatchID | int | YES | ||
| SaRefundCalcID | int | YES | ||
| AddUserID | int | NO | ||
| UserID | int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
| AmDepositID | int | YES | ||
| CCAuthNum | char(10) | YES | ||
| CCDeclineCode | char(10) | YES | ||
| SyAddressID | int | YES | ||
| SaQTBatchID | int | YES | ||
| SA1098T | char(1) | NO | ||
SaACHBatchID |
int | YES | ||
| DateReceiptPrinted | datetime | YES | ||
| SaCreditCardBatchId | int | YES | ||
saCashDrawerSessionID |
int | YES | ||
| ManualCheckExtractFlag | bit | YES | ||
AdCourseID |
int | YES | ||
| SaTuitionDiscountPolicyID | int | YES | ||
| OriginalSaTransId | int | YES | ||
AmAgencyCCID |
int | YES | ||
| CheckStatus | char(1) | NO | ||
| CheckClearedDate | datetime | YES | ||
| Sa1098TPrevYear | bit | NO | ||
AdClassSchedID |
int | YES | ||
| MerchantProcessingCode | varchar(19) | YES | ||
FaStudentAyPaymentPeriodId |
int | YES | ||
| EFTNumber | varchar(20) | YES | ||
| EFTStatus | char(1) | YES | ||
| EFTClearedDate | datetime | YES | ||
SaCourseRefundPolicyId |
int | YES | ||
| CourseAmountToRetain | money | YES | ||
| RegAdTermID | int | YES | ||
| ProcessByAutomation | bit | NO | ||
AdFeesId |
int | YES | ||
| GLStatusFlag | bit | NO | ||
| IsReIssue | bit | NO | ||
| IsInPendingQueue | bit | NO | ||
| IsCNFReconciled | bit | NO | ||
| TransDueDate | char(10) | YES | ||
SaStudentBankAccountId |
int | YES | ||
| DRN | char(10) | YES | ||
| VRN | char(10) | YES |
| SaTrans Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SaTrans_SyCampusID_SaBankDepID_Type_Ref_Source_SaTransID_U_N_IDX | Index | SyCampusID, SaBankDepID, Type, Ref, Source, SaTransID |
| SaTrans_SaTransID_U_C_IDX | PrimaryKey | SaTransID |
| SaTrans_AdEnrollId_AdTermId_SaBillCode_Source_Type_Amount_SaTransID_U_N_IDX | Index | AdEnrollID, AdTermID, SaBillCode, Source, SaTransID |
| SaTrans_PostDate_Source_SaBankAccountID_SaTransID_U_N_IDX | Index | PostDate, Source, SaBankAccountID, SaTransID |
| SaTrans_SyCampusId_AdEnrollId_AdTermId_Type_Amount_Date_SaTransId_U_N_IDX | Index | SyCampusID, AdEnrollID, AdTermID, Type, Amount, Date, SaTransID |
| SaTrans Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| saCashDrawerSession | Non-Identifying | Zero or One to Zero or More | FK_saTrans.saCashDrawerSessionID_saCashDrawerSession.saCashDrawerSessionID | saCashDrawerSessionID | NO | YES | ||
| AdClassSched | Non-Identifying | Zero or One to Zero or More | Fk_SaTrans_AdClassSchedID_AdClassSched_AdClassSchedID | AdClassSchedID | NO | YES | ||
| AdCourse | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_AdCourseID_AdCourse_AdCourseID | AdCourseID | NO | YES | ||
| AdFees | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_AdFeesId_AdFees_AdFeesId | AdFeesId | NO | YES | ||
| AmAgencyCC | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_AmAgencyCCID_AmAgencyCC_AmAgencyCCID | AmAgencyCCID | NO | YES | ||
| FaStudentAYPaymentPeriod | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_FaStudentAyPaymentPeriodId_FaStudentAyPaymentPeriod_FaStudentAyPaymentPeriodId | FaStudentAyPaymentPeriodId | NO | YES | ||
| SaACHBatch | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_SaACHBatchID_SaACHBatch_SaACHBatchID | SaACHBatchID | NO | YES | ||
| SaCourseRefundPolicy | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_SaCourseRefundPolicyId_SaCourseRefundPolicy_SaCourseRefundPolicyId | SaCourseRefundPolicyId | NO | YES | ||
| SaStudentBankAccount | Non-Identifying | Zero or One to Zero or More | FK_SaTrans_SaStudentBankAccountId_SaStudentBankAccount_SaStudentBankAccountId | SaStudentBankAccountId | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SaAutoStipendPaymentQueue | Non-Identifying | One To Zero or More | FK_SaAutoStipendPaymentQueueSaTransID_SaTransSaTransID | NO | YES | |||
| SaDisbReceiptNotification | Non-Identifying | One To Zero or More | FK_SaDisbReceiptNotificationSaTransID_SaTransSaTransID | NO | YES | |||
| SaStudentLedgerTermUpdatesArchive | Non-Identifying | One To Zero or More | FK_SaStudentLedgerTermUpdatesArchive_SaTransID_SaTrans_SaTransID | NO | YES | |||
| SaTransCourse | Non-Identifying | One To Zero or More | FK_SaTransCourse_SaTransID_SaTrans_SaTransID | NO | YES | |||
| SaTransCourseAmount | Non-Identifying | One To Zero or More | FK_SaTransCourseAmount_SaTransId_SaTrans_SaTransId | NO | YES | |||
| SaTransFee | Non-Identifying | One To Zero or More | FK_SaTransFee_SaTransID_SaTrans_SaTransID | NO | YES |
| SaTrans Check Constraints |
| Check Constraint Name | CheckConstraint |